<!DOCTYPE html>
<html lang="zh-Hans">

<head>
    <meta charset="utf-8">
    <!--   <meta content="IE=edge" http-equiv="X-UA-Compatible"> -->
    <meta content="width=device-width, initial-scale=1" name="viewport">
    <meta content="" name="description">
    <meta content="" name="author">
    <link href="ico/favicon.ico" rel="shortcut icon">

    <title>O.Push Backend</title>

    <!-- Bootstrap core CSS -->
    <link rel="stylesheet" href="css/bootstrap.css">
    <!-- Bootstrap theme -->
    <!--  <link rel="stylesheet" href="css/bootstrap-theme.min.css"> -->

    <!-- Custom styles for this template -->
    <link rel="stylesheet" href="css/theme.css">
    <link rel="stylesheet" href="css/dashboard.css">
    <link rel="stylesheet" href="css/style.css">
    <link rel="stylesheet" href="css/dripicon.css">
    <link rel="stylesheet" href="css/typicons.css" />
    <link rel="stylesheet" href="css/font-awesome.css" />
    <link rel="stylesheet" href="css/responsive.css">
    <link rel="stylesheet" href="js/tip/tooltipster.css">
    <link rel="stylesheet" type="text/css" href="js/vegas/jquery.vegas.css" />
    <link rel="stylesheet" type="text/css" href="js/number-progress-bar/number-pb.css">
    <!-- pace loader -->
    <script src="js/pace/pace.js"></script>
    <link href="js/pace/themes/orange/pace-theme-flash.css" rel="stylesheet" />



</head>

<body role="document">

    <div id="preloader">
        <div id="status">&nbsp;</div>
    </div>

    <!-- TOPNAV -->

    <div class="row">
        <div class="col-lg-3">
            <ul class="nav navbar-nav navbar-left list-unstyled list-inline text-amber date-list">
                <li><i class="fontello-th text-amber"></i>
                </li>
                <li id="Date"></li>
            </ul>
            <ul class="nav navbar-nav navbar-left list-unstyled list-inline text-amber date-list">
                <li><i class="fontello-stopwatch text-amber"></i>
                </li>
                <li id="hours"></li>
                <li class="point">:</li>
                <li id="min"></li>
                <li class="point">:</li>
                <li id="sec"></li>
            </ul>


        </div>
        <div class="col-lg-6">
            <div style="margin-bottom:0;" class="alert text-white ">
                <span class="entypo-info-circled"></span>
                <strong>Wellcome back!</strong>&nbsp;&nbsp;Joe, your last loggin was 1 day ago. Have a nice day
            </div>
        </div>

    </div>
    <!-- END OF TOPNAV -->
    <!-- Comtainer -->
    <div class="container-fluid paper-wrap bevel tlbr">
        <div id="paper-top">
            <div class="row">
                <div class="col-sm-3 no-pad">

                    <a class="navbar-brand logo-text" href="#">O.Push Team Backend</a>

                    <ul class="list-unstyled list-inline noft-btn">
                        <li data-toggle="tooltip" data-placement="bottom" title="Log Out"> 
							<a href="login.html" class="text-white"><i class="icon-upload"></i></a>
                        </li>

                    </ul>
                </div>

                <div class="col-sm-6 no-pad">
                    <ul style="margin-top:8px;" class="nav navbar-nav navbar-left list-unstyled list-inline text-gray date-list news-list">
                        <!-- <li><i class="fontello-doc-text text-gray"></i>
                        </li> -->
                        <li>
                            <ul class="list-unstyled top-newsticker text-gray news-list">
                                <li><i class="fontello-cloud-flash-inv text-gray"></i>&nbsp;&nbsp;
                                    <strong>Noti title 1,</strong>noti body 1 &nbsp;<b>strong text</b>
                                </li>
                                <li><i class="fontello-cloud-sun-inv text-gray"></i>&nbsp;&nbsp;
                                    <strong>Noti title 2,</strong>noti body 2 &nbsp;<b>strong text</b>
                                </li>
                                <li><i class="fontello-rain-inv text-gray"></i>&nbsp;&nbsp;
                                    <strong>Noti title 3,</strong>noti body 3 &nbsp;<b>strong text</b>
                                </li>
                            </ul>
                        </li>
                    </ul>

                </div>
            </div>
        </div>

        <!-- SIDE MENU -->
        <div class="wrap-sidebar-content">
            <div id="skin-select">
                <a id="toggle">
                    <span class="fa icon-menu"></span>
                </a>

                <div class="skin-part">
                    <div id="tree-wrap">
                        <div class="side-bar">
                            <ul id="menu-showhide" class="topnav">
                                <li class="devider-title">
                                    <h3>
                                        <span>Menu</span>
                                    </h3>
                                </li>
                                <li>
                                    <a class="tooltip-tip" href="weixin_sdk.html" title="Weixin">
                                        <i class="fontello-desktop-1"></i>
                                        <span>Weixin SDKs Helper</span>
                                    </a>
                                </li>
                                <li class="active">
                                    <a class="tooltip-tip" href="net_sdk.html" title=".Net">
                                        <i class="fontello-desktop-1"></i>
                                        <span>.Net SDKs Helper</span>
                                    </a>
                                </li>
								<li>
                                    <a class="tooltip-tip" href="dashboard_controls.html" title="Dashboard">
                                        <i class="fontello-desktop-1"></i>
                                        <span>Dashboard Controls</span>
                                    </a>
                                </li>
                            </ul>
                            <div class="side-dash">
                                <h3>
                                    <span>Server Status</span>
                                </h3>
                                <ul class="side-dashh-list">
                                    <li>
                                        <!-- Task item -->
                                        <a href="#">
                                            <h3 class="fontello-leaf">
                                                Storage Status
                                                <small class="pull-right">35%</small>
                                            </h3>
                                            <div class="progress xs bg-opacity-one height-tiny">
                                                <div class="progress-bar bg-blue " style="width: 35%" role="progressbar" aria-valuenow="20" aria-valuemin="0" aria-valuemax="100">
                                                    <span class="sr-only">35% Complete</span>
                                                </div>
                                            </div>
                                        </a>
                                    </li>
                                    <!-- end task item -->
                                    <li>
                                        <!-- Task item -->
                                        <a href="#">
                                            <h3 class="fontello-box">
                                                CPU Usage
                                                <small class="pull-right">40%</small>
                                            </h3>
                                            <div class="progress xs bg-opacity-one height-tiny">
                                                <div class="progress-bar bg-aqua" style="width: 40%" role="progressbar" aria-valuenow="20" aria-valuemin="0" aria-valuemax="100">
                                                    <span class="sr-only">40% Complete</span>
                                                </div>
                                            </div>
                                        </a>
                                    </li>
                                    <!-- end task item -->
                                </ul>
                                <div id="doughnutChart" class="chart"></div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <!-- #/skin-select -->
            <!-- END OF SIDE MENU -->

            <!-- Breadcrumb -->
            <div class="sub-board">
                <span class="header-icon"><i class="fontello-home"></i>
                </span>
                <ol class="breadcrumb newcrumb ng-scope">
                    <li>
                        <a href="#">
                            <span>
                            </span>Weixin Private API</a>
                    </li>

                </ol>
            </div>
            <!-- End of Breadcrumb -->

			
            <!-- CONTENT -->
            <div class="wrap-fluid" id="paper-bg">
				<div class="row">
					<div class="col-lg-6">
						 <div class="box">
								<div class="box-header">

									<h3 class="box-title">
										<span>数据库操作 -> 增删改 (异步)</span>
									</h3>
								</div>
								<!-- /.box-header -->
								<div class="box-body">
									<p><code>基本用法</code></p>
<pre>
[HttpPost]
public async Task&lt;ZKResponse&gt; SampleOP(SampleModel model)
{
	ZKResponse response = new ZKResponse();
	await MySQLOperationManager.doSQLOperationAsync(cmd =>
		{
			cmd.CommandText = "sample_procedure";  //sql或者存储过程名称
			cmd.Parameters.Add("?p1", model.value1, ParameterDirection.Input); //存储过程参数
		},
		e => //错误回调
		{
			if (e != null)
			{
				response.isProcessSuccess = false;
				response.errMsg = e;
			}
		}, 
		CommandType.StoredProcedure, //命令类型、存储过程或sql
		false);		//是否使用transaction
	return response;	//返回给client的object
}
</pre>
								</div>
								<!-- /.box-body -->
						</div>
						<div class="box">
								<div class="box-header">

									<h3 class="box-title">
										<span>Resources Downloads</span>
									</h3>
								</div>
								<!-- /.box-header -->
								<div class="box-body">
									<p><code>Urls</code></p>
<pre>
MariaDB 								<a href="https://mariadb.org/">Downloads</a>
VS2013 									<a href="http://www.musnow.com/thread-54-1-1.html">Downloads</a>
</pre>
								</div>
								<!-- /.box-body -->
						</div>
					</div>
			<div class="col-lg-6">
						<div class="box">
								<div class="box-header">

									<h3 class="box-title">
										<span>数据库操作 -> 查询 (异步)</span>
									</h3>
								</div>
								<!-- /.box-header -->
								<div class="box-body">
									<p><code>基本用法</code></p>
<pre>
[HttpPost]
public async Task&lt;ZKResponse&gt; SampleOP(SampleModel model)
{
	ZKResponse response = new ZKResponse();
	await MySQLOperationManager.doSQLOperationWithLoadedDataAsync(cmd =>
		{
			cmd.CommandText = "sample_procedure";	//sql或者存储过程名称
			cmd.Parameters.Add("?p1", model.value1, ParameterDirection.Input);	//存储过程参数
		},
		e =>	//错误回调
		{
			if (e != null)
			{
				response.isProcessSuccess = false;
				response.errMsg = e;
			}
		},
		data=>	//数据回调
		{
			//data callbacks
		},
		CommandType.StoredProcedure, 	//命令类型、存储过程或sql
		false);		//是否使用transaction
	return response;
}
</pre>
								</div>
								<!-- /.box-body -->
						</div>
					</div>
				</div>
            </div>
            <!-- #/paper bg -->
        </div>
        <!-- ./wrap-sidebar-content -->

        <!-- / END OF CONTENT -->

        <!-- FOOTER -->
        <div id="footer">
            <div class="devider-footer-left"></div>
            <div class="time">
                <p id="spanDate"></p>
                <p id="clock"></p>
            </div>
            <div class="copyright">Copyright &copy; <a href="http://www.opush.mobi/">O.Push Team</a> Made with <i class="fontello-heart-filled text-red"></i>
            </div>
            <div class="devider-footer"></div>
            <ul>
            </ul>
        </div>
        <!-- / FOOTER -->
    </div>
    <!-- Container -->





    <!-- 
    ================================================== -->
    <!-- Main jQuery Plugins -->
    <script type='text/javascript' src="js/jquery.js"></script>
    <script type='text/javascript' src='js/bootstrap.js'></script>
    <script type='text/javascript' src='js/date.js'></script>
    <script type='text/javascript' src='js/slimscroll/jquery.slimscroll.js'></script>
    <script type='text/javascript' src='js/jquery.nicescroll.min.js'></script>
    <!--  minimize setting -->
    <script type='text/javascript' src='js/sliding-menu-minimize.js'></script>
    <!--  end minimize setting -->
    <script type='text/javascript' src='js/scriptbreaker-multiple-accordion-1.js'></script>
    <script type='text/javascript' src='js/tip/jquery.tooltipster.min.js'></script>
    <script type='text/javascript' src="js/donut-chart/jquery.drawDoughnutChart.js"></script>
    <script type='text/javascript' src="js/tab/jquery.newsTicker.js"></script>
    <script type='text/javascript' src="js/tab/app.ticker.js"></script>
    <script type='text/javascript' src='js/app.js'></script>

    <script type='text/javascript' src='js/vegas/jquery.vegas.js'></script>
    <script type='text/javascript' src='js/image-background.js'></script>
    <script type="text/javascript" src="js/jquery.tabSlideOut.v1.3.js"></script>
    <script type="text/javascript" src="js/bg-changer.js"></script>


    <script type='text/javascript' src="js/number-progress-bar/jquery.velocity.min.js"></script>
    <script type='text/javascript' src="js/number-progress-bar/number-pb.js"></script>
    <script src="js/loader/loader.js" type="text/javascript"></script>
    <script src="js/loader/demo.js" type="text/javascript"></script>
    <script type="text/javascript" src="js/skycons/skycons.js"></script>

    <!-- TAB SLIDER -->

    <script src="js/chartist/chartist.min.js"></script>

    <script>
    //Icons
    (function($) {
        "use strict";
        var icons = new Skycons({
                "stroke": 0.08,
                "color": "Gray",
                "cloudColor": "#65C3DF",
                "sunColor": "#0090d9",
                "moonColor": "DodgerBlue",
                "rainColor": "RoyalBlue",
                "snowColor": "LightGray",
                "windColor": "LightSteelBlue",
                "fogColor": "#65C3DF"
            }),
            list = [
                "clear-day", "clear-night", "partly-cloudy-day",
                "partly-cloudy-night", "cloudy", "rain", "sleet", "snow", "wind",
                "fog"
            ],
            i;

        for (i = list.length; i--;)
            icons.set(list[i], list[i]);
        icons.play();
    })(jQuery);

    </script>






</body>
</html>
